package guoanmaker.operator.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.operator.business.model.ProviderBusinessServerRange;

public interface ProviderBusinessServerRangeRepository extends  JpaRepository<ProviderBusinessServerRange, String>, JpaSpecificationExecutor<ProviderBusinessServerRange> {

	@Query("select r from  ProviderBusinessServerRange r   left join r.business b where b.id=:id")
	public List<ProviderBusinessServerRange>  selectByServerRange(@Param("id") String id);
	
	
	
	
	
}
